Create a stored procedure for real life problem part 1 in sql server